﻿namespace LanSunERP
{
    using System;
    using System.ServiceModel;
    using System.Windows.Forms;
    using System.Diagnostics;
    using System.Collections.Generic;
    using System.Runtime.Serialization;
    using System.Collections;
    using System.Data;
    using System.Data.SqlClient;

    public class Multi_Table : QueryCommand
    {
        public Multi_Table() : base() { }
        public Multi_Table(SqlCommand cmdSQL, DataTable dtRequest, string RequestJob)
            : base(cmdSQL, dtRequest, RequestJob) { }

        public SqlCommand BuildCommand()
        {
           switch (RequestJob.Substring(6, 4))
            {
                case "3000010000":
                    break;
                case "3000010002":
                    break;
                case "3000010003":
                    break;
                case "3000010005":
                    cmdSQL.Parameters.Add(new SqlParameter("@table_name", dwRequest["table_name"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@table_Short", dwRequest["table_Short"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@tableid", dwRequest["tableid"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@SysID", dwRequest["conditions"].ToString()));
                    cmdSQL.Parameters.Add(new SqlParameter("@conditions", dwRequest["conditions"].ToString()));
                    break;
                default:
                    break;
            }
            return cmdSQL;

        }

    }
}